2013-07-01 - 7902 - Rel Notes - ICD100 - Enhancements #BIReleases2013
Release Notes
7902 - ICD100 Enhancements
Admin Info
Purpose
|
To investigate ICD100 Report about the E-Mail size and the Date being not displayed in European format
|
Release No
|
001
|
Submitted
|
07/01/2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality folder to IT > BMS > Production folder
|
Release Sent To
|
Will Cartwright
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
ICD100 - PO Report by ICD.
NEC Crystal Reports Standards Check
1. ICD100 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. ICD100 NEC CR checklist has been sent to NEC and also attached here for reference:
ICD100 NEC CR Standard Check List.xlsx
Release Notes
For Infrastructure
None
For Requestor
Solution for Requirement on 07/01/2013 via IM :
1. Need to schedule the report with single USA region Plant and set destination to E-Mail & file format to *.CSV.
2. Need to apply all the USA Region Plants parameter and schedule the report, set destination to E-Mail & file format to *.CSV.
3. Need to change the file format to PDF and set the destination to E-mail.
4. Need to change the destination to BI Inbox and set the file format to *.CSV.
5. Need to check the PDF file size and *.CSV file size.
6. Need to contact Infrastructure regarding the file size limitation on SMTP server for *.CSV files.
Solution for Requirement on 07/02/2013 via IM :
1. Need to apply the Date format logic at Crystal Report Designer level to show the Date format based on Plant values.
2. Need to apply Date format logic to change the date format form MM/DD/YYYY to DD/MM/YYYY and vice-versa .
Solution for Requirement on 07/02/2013 via E-mail :
1. Need to create date format formulas in Crystal Report designer to show the date format based on Plant prompt values.
Solution for Requirement on 07/05/2013 via IM :
1. Need to add File system for Crystal Job server in CMC for development server.
Solution for Requirement on 07/09/2013 via IM :
1. Need to check the values in T001K table using Crystal report.
2. Need to create formulas in Crystal Report to show the date format as per requirement.
3. Need to check the users list in BOBI 4.0 production server.
4. Need to hard code all the specific region BO Users in Crystal Report.
5. Need to create formulas to show the specific date formats using User Time Zone function.
6. Need to create formulas to show the specific date formats using Print Time Zone function.
7. Need to check whether time zone associated with the BO user ID.
8. Need to create a Date Format parameter which will have Date formats as input prompt values in Crystal report.
Test Notes
SNo
|
Test Scenario
|
Expected Results
|
1
|
Scheduled the report in NEC Infoview after changes.
|
Report succesfully scheduled in NEC infoview.
|
2
|
Validated the new report with NEC Standard.
|
Validation is successful.
|
Reference Document(Specification)
2013-07-01 - 7902 - Enhancement - ICD100 - Enhancements